Visual Novel Database dataset report

Dataset statistics

Number of variables	20
Number of observations	13495
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	355.9 KiB
Average record size in memory	27.0 B

Variable types

BOOL	11
NUM	8
CAT	1

Warnings

`df_index` has unique values	Unique
`voiced` has 5268 (39.0%) zeros	Zeros
`ani_story` has 8402 (62.3%) zeros	Zeros
`ani_ero` has 10486 (77.7%) zeros	Zeros

Reproduction

Analysis started	2020-10-29 12:30:04.159212
Analysis finished	2020-10-29 12:30:16.656948
Duration	12.5 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	13495
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	35731.83942
Minimum	0
Maximum	71510
Zeros	1
Zeros (%)	< 0.1%
Memory size	105.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1608.7
Q1	20005
median	37457
Q3	52177.5
95-th percentile	66694.3
Maximum	71510
Range	71510
Interquartile range (IQR)	32172.5

Descriptive statistics

Standard deviation	20270.15712
Coefficient of variation (CV)	0.5672855763
Kurtosis	-1.06056629
Mean	35731.83942
Median Absolute Deviation (MAD)	15942
Skewness	-0.1718357802
Sum	482201173
Variance	410879269.6
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36862	1	< 0.1%
70359	1	< 0.1%
54047	1	< 0.1%
23326	1	< 0.1%
51996	1	< 0.1%
62235	1	< 0.1%
60184	1	< 0.1%
35604	1	< 0.1%
41745	1	< 0.1%
43792	1	< 0.1%
Other values (13485)	13485	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
71510	1	< 0.1%
71505	1	< 0.1%
71500	1	< 0.1%
71442	1	< 0.1%
71440	1	< 0.1%

type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	13.2 KiB

0	11124
2	1530
1	841

Frequencies
Length

Value	Count	Frequency (%)
0	11124	82.4%
2	1530	11.3%
1	841	6.2%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

patch
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	13.2 KiB

0	10998
1	2497

Common Values
Chart

Value	Count	Frequency (%)
0	10998	81.5%
1	2497	18.5%

freeware
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	13.2 KiB

0	8724
1	4771

Common Values
Chart

Value	Count	Frequency (%)
0	8724	64.6%
1	4771	35.4%

doujin
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	13.2 KiB

0	11842
1	1653

Common Values
Chart

Value	Count	Frequency (%)
0	11842	87.8%
1	1653	12.2%

voiced
Real number (ℝ_≥0)

ZEROS

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.111004076
Minimum	0
Maximum	4
Zeros	5268
Zeros (%)	39.0%
Memory size	13.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3
Q3	4
95-th percentile	4
Maximum	4
Range	4
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.881113686
Coefficient of variation (CV)	0.8910990307
Kurtosis	-1.899453364
Mean	2.111004076
Median Absolute Deviation (MAD)	1
Skewness	-0.09784837754
Sum	28488
Variance	3.538588698
Monotocity	Not monotonic

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
4	6207	46.0%
0	5268	39.0%
1	1198	8.9%
3	818	6.1%
2	4	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5268	39.0%
1	1198	8.9%
2	4	< 0.1%
3	818	6.1%
4	6207	46.0%

Value	Count	Frequency (%)
4	6207	46.0%
3	818	6.1%
2	4	< 0.1%
1	1198	8.9%
0	5268	39.0%

ani_story
Real number (ℝ_≥0)

ZEROS

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.6117821415
Minimum	0
Maximum	4
Zeros	8402
Zeros (%)	62.3%
Memory size	13.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	4
Range	4
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.9043939739
Coefficient of variation (CV)	1.478294171
Kurtosis	1.120732806
Mean	0.6117821415
Median Absolute Deviation (MAD)	0
Skewness	1.365172939
Sum	8256
Variance	0.81792846
Monotocity	Not monotonic

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
0	8402	62.3%
1	2566	19.0%
2	2008	14.9%
3	402	3.0%
4	117	0.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8402	62.3%
1	2566	19.0%
2	2008	14.9%
3	402	3.0%
4	117	0.9%

Value	Count	Frequency (%)
4	117	0.9%
3	402	3.0%
2	2008	14.9%
1	2566	19.0%
0	8402	62.3%

ani_ero
Real number (ℝ_≥0)

ZEROS

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.2971470915
Minimum	0
Maximum	4
Zeros	10486
Zeros (%)	77.7%
Memory size	13.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	4
Range	4
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.6480146146
Coefficient of variation (CV)	2.180787338
Kurtosis	8.745411176
Mean	0.2971470915
Median Absolute Deviation (MAD)	0
Skewness	2.743001357
Sum	4010
Variance	0.4199229408
Monotocity	Not monotonic

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
0	10486	77.7%
1	2367	17.5%
2	347	2.6%
3	231	1.7%
4	64	0.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	10486	77.7%
1	2367	17.5%
2	347	2.6%
3	231	1.7%
4	64	0.5%

Value	Count	Frequency (%)
4	64	0.5%
3	231	1.7%
2	347	2.6%
1	2367	17.5%
0	10486	77.7%

uncensored
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	13.2 KiB

0	12882
1	613

Common Values
Chart

Value	Count	Frequency (%)
0	12882	95.5%
1	613	4.5%

engine
Real number (ℝ_≥0)

Distinct	92
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	157.9442016
Minimum	1
Maximum	184
Zeros	0
Zeros (%)	0.0%
Memory size	13.2 KiB

Quantile statistics

Minimum	1
5-th percentile	58
Q1	178
median	178
Q3	178
95-th percentile	178
Maximum	184
Range	183
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	40.3272178
Coefficient of variation (CV)	0.2553257252
Kurtosis	2.838293411
Mean	157.9442016
Median Absolute Deviation (MAD)	0
Skewness	-1.973254274
Sum	2131457
Variance	1626.284496
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
178	10127	75.0%
85	789	5.8%
126	778	5.8%
31	188	1.4%
39	145	1.1%
166	106	0.8%
125	100	0.7%
153	92	0.7%
106	91	0.7%
30	91	0.7%
Other values (82)	988	7.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	3	< 0.1%
2	38	0.3%
3	2	< 0.1%
9	8	0.1%
13	2	< 0.1%

Value	Count	Frequency (%)
184	3	< 0.1%
182	2	< 0.1%
178	10127	75.0%
177	2	< 0.1%
176	44	0.3%

l_steam
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	13.2 KiB

1	12868
0	627

Common Values
Chart

Value	Count	Frequency (%)
1	12868	95.4%
0	627	4.6%

l_digiket
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	13.2 KiB

1	12867
0	628

Common Values
Chart

Value	Count	Frequency (%)
1	12867	95.3%
0	628	4.7%

l_melon
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	13.2 KiB

1	13491
0	4

Common Values
Chart

Value	Count	Frequency (%)
1	13491	> 99.9%
0	4	< 0.1%

l_mg
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	13.2 KiB

1	13265
0	230

Common Values
Chart

Value	Count	Frequency (%)
1	13265	98.3%
0	230	1.7%

l_getchu
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	13.2 KiB

1	12859
0	636

Common Values
Chart

Value	Count	Frequency (%)
1	12859	95.3%
0	636	4.7%

l_toranoana
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	13.2 KiB

1	13400
0	95

Common Values
Chart

Value	Count	Frequency (%)
1	13400	99.3%
0	95	0.7%

l_melonjp
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	13.2 KiB

1	13366
0	129

Common Values
Chart

Value	Count	Frequency (%)
1	13366	99.0%
0	129	1.0%

lang
Real number (ℝ_≥0)

Distinct	31
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	17.50633568
Minimum	0
Maximum	39
Zeros	2
Zeros (%)	< 0.1%
Memory size	13.2 KiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	17
median	17
Q3	17
95-th percentile	37
Maximum	39
Range	39
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	8.102130837
Coefficient of variation (CV)	0.4628113493
Kurtosis	1.689457476
Mean	17.50633568
Median Absolute Deviation (MAD)	0
Skewness	1.15240838
Sum	236248
Variance	65.64452411
Monotocity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
17	9365	69.4%
6	2049	15.2%
37	685	5.1%
39	581	4.3%
29	321	2.4%
8	138	1.0%
18	94	0.7%
10	67	0.5%
26	38	0.3%
16	29	0.2%
Other values (21)	128	0.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	4	< 0.1%
5	29	0.2%

Value	Count	Frequency (%)
39	581	4.3%
38	26	0.2%
37	685	5.1%
35	5	< 0.1%
34	2	< 0.1%

month
Real number (ℝ_≥0)

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6.676546869
Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Memory size	13.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.433752628
Coefficient of variation (CV)	0.514300685
Kurtosis	-1.210126169
Mean	6.676546869
Median Absolute Deviation (MAD)	3
Skewness	-0.03526127363
Sum	90100
Variance	11.79065711
Monotocity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
12	1302	9.6%
4	1208	9.0%
10	1193	8.8%
7	1182	8.8%
9	1153	8.5%
8	1139	8.4%
3	1132	8.4%
11	1076	8.0%
6	1066	7.9%
5	1058	7.8%
Other values (2)	1986	14.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	939	7.0%
2	1047	7.8%
3	1132	8.4%
4	1208	9.0%
5	1058	7.8%

Value	Count	Frequency (%)
12	1302	9.6%
11	1076	8.0%
10	1193	8.8%
9	1153	8.5%
8	1139	8.4%

c_popularity
Real number (ℝ_≥0)

Distinct	52
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.040311226
Minimum	1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Memory size	13.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	7
95-th percentile	40
Maximum	100
Range	99
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	14.79518304
Coefficient of variation (CV)	1.840125665
Kurtosis	12.5356588
Mean	8.040311226
Median Absolute Deviation (MAD)	1
Skewness	3.359126292
Sum	108504
Variance	218.8974411
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	5277	39.1%
2	1965	14.6%
3	1111	8.2%
4	827	6.1%
5	439	3.3%
6	352	2.6%
7	315	2.3%
9	272	2.0%
8	248	1.8%
18	195	1.4%
Other values (42)	2494	18.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5277	39.1%
2	1965	14.6%
3	1111	8.2%
4	827	6.1%
5	439	3.3%

Value	Count	Frequency (%)
100	36	0.3%
87	37	0.3%
85	24	0.2%
80	89	0.7%
77	28	0.2%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	df_index	voiced	ani_story	ani_ero	uncensored	engine	l_steam	l_digiket	l_melon	l_mg	l_getchu	l_toranoana	l_melonjp	lang	month	c_popularity
0	0	0	0	0	0	178	1	1	1	1	1	1	1	37	10	4
1	1	4	3	1	0	178	1	1	1	1	1	1	1	17	2	65
2	2	3	1	1	1	74	1	1	1	1	1	1	1	17	8	4
3	3	1	1	1	0	74	1	1	1	1	1	1	1	6	6	15
4	4	1	1	1	0	178	1	1	1	1	0	1	1	17	6	15
5	5	4	3	1	0	178	1	1	1	1	1	1	1	17	3	65
6	6	4	3	0	0	178	1	1	1	1	1	1	1	17	9	65
7	7	4	2	1	0	178	1	1	1	1	1	1	1	17	2	42
8	8	4	2	1	0	178	1	1	1	1	1	1	1	17	4	42
9	9	1	1	1	1	74	1	1	1	1	1	1	1	17	7	15

Last rows

	df_index	patch	freeware	doujin	voiced	ani_story	ani_ero	engine	l_steam	l_digiket	l_melon	l_mg	l_getchu	l_toranoana	l_melonjp	lang	month	c_popularity
13485	71410	0	1	1	1	2	0	106	1	1	1	1	1	1	1	17	10	3
13486	71426	0	0	0	4	0	0	178	1	0	1	1	1	1	1	6	5	4
13487	71427	0	0	0	4	0	0	178	1	0	1	1	1	1	1	6	6	4
13488	71428	0	0	0	4	1	1	178	1	0	1	1	1	1	1	17	4	3
13489	71429	0	0	0	4	1	1	178	1	0	1	1	1	1	1	17	4	6
13490	71440	0	0	0	4	0	0	2	1	1	1	1	1	1	1	6	10	1
13491	71442	0	0	0	4	0	0	178	1	1	1	1	0	1	1	17	12	41
13492	71500	0	1	1	1	2	0	106	1	1	1	1	1	1	1	17	10	3
13493	71505	0	0	0	4	0	0	178	1	1	1	1	1	1	1	6	10	1
13494	71510	1	1	0	0	0	0	178	1	1	1	1	1	1	1	17	10	4

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows

	df_index	voiced	ani_story	ani_ero	uncensored	engine	l_steam	l_digiket	l_melon	l_mg	l_getchu	l_toranoana	l_melonjp	lang	month	c_popularity
0	0	0	0	0	0	178	1	1	1	1	1	1	1	37	10	4
1	1	4	3	1	0	178	1	1	1	1	1	1	1	17	2	65
2	2	3	1	1	1	74	1	1	1	1	1	1	1	17	8	4
3	3	1	1	1	0	74	1	1	1	1	1	1	1	6	6	15
4	4	1	1	1	0	178	1	1	1	1	0	1	1	17	6	15
5	5	4	3	1	0	178	1	1	1	1	1	1	1	17	3	65
6	6	4	3	0	0	178	1	1	1	1	1	1	1	17	9	65
7	7	4	2	1	0	178	1	1	1	1	1	1	1	17	2	42
8	8	4	2	1	0	178	1	1	1	1	1	1	1	17	4	42
9	9	1	1	1	1	74	1	1	1	1	1	1	1	17	7	15

	df_index	voiced	ani_story	ani_ero	uncensored	engine	l_steam	l_digiket	l_melon	l_mg	l_getchu	l_toranoana	l_melonjp	lang	month	c_popularity
0	0	0	0	0	0	178	1	1	1	1	1	1	1	37	10	4
1	1	4	3	1	0	178	1	1	1	1	1	1	1	17	2	65
2	2	3	1	1	1	74	1	1	1	1	1	1	1	17	8	4
3	3	1	1	1	0	74	1	1	1	1	1	1	1	6	6	15
4	4	1	1	1	0	178	1	1	1	1	0	1	1	17	6	15
5	5	4	3	1	0	178	1	1	1	1	1	1	1	17	3	65
6	6	4	3	0	0	178	1	1	1	1	1	1	1	17	9	65
7	7	4	2	1	0	178	1	1	1	1	1	1	1	17	2	42
8	8	4	2	1	0	178	1	1	1	1	1	1	1	17	4	42
9	9	1	1	1	1	74	1	1	1	1	1	1	1	17	7	15

	df_index	voiced	ani_story	ani_ero	uncensored	engine	l_steam	l_digiket	l_melon	l_mg	l_getchu	l_toranoana	l_melonjp	lang	month	c_popularity
0	0	0	0	0	0	178	1	1	1	1	1	1	1	37	10	4
1	1	4	3	1	0	178	1	1	1	1	1	1	1	17	2	65
2	2	3	1	1	1	74	1	1	1	1	1	1	1	17	8	4
3	3	1	1	1	0	74	1	1	1	1	1	1	1	6	6	15
4	4	1	1	1	0	178	1	1	1	1	0	1	1	17	6	15
5	5	4	3	1	0	178	1	1	1	1	1	1	1	17	3	65
6	6	4	3	0	0	178	1	1	1	1	1	1	1	17	9	65
7	7	4	2	1	0	178	1	1	1	1	1	1	1	17	2	42
8	8	4	2	1	0	178	1	1	1	1	1	1	1	17	4	42
9	9	1	1	1	1	74	1	1	1	1	1	1	1	17	7	15